<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#66CCFF" text="#000000">
<%@ page import ="java.sql.*"%>
<%
int gcode=Integer.parseInt(request.getParameter("groupcode"));
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 	Connection con=DriverManager.getConnection("jdbc:odbc:psi","psi","psi");
 	Statement st=con.createStatement();
 	ResultSet rs=st.executeQuery("select e.emp_code,e.emp_name,g.pro_code,g.gro_size from pro_group g, employee e where e.gro_code=g.gro_code and g.gro_code="+gcode); 	
 %>
<div align="center">
  <p><font face="Arial, Helvetica, sans-serif" color="#993300" size="4">Group 
    Status Report</font> </p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp; </p>
  <table width="49%" border="1" align="center">
    <tr> 
      <td width="18%">EmpCode</td>
      <td width="31%">EmployeeName</td>
      <td width="26%">ProjectCode</td>
      <td width="25%">GroupSize</td>
    </tr>
    <%while(rs.next()){%>
    <tr> 
      <td width="18%">&nbsp;<%=rs.getString(1)%></td>
      <td width="31%">&nbsp;<%=rs.getString(2)%></td>
      <td width="26%">&nbsp;<%=rs.getString(3)%></td>
      <td width="25%">&nbsp;<%=rs.getString(4)%></td>
    </tr>
    <%}%>
  </table>
</div>
</body>
</html>
